<%@ page import="java.util.List" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.DriverManager" %><%--
  Created by IntelliJ IDEA.
  User: Administrator
  Date: 2018/4/3
  Time: 19:46
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
  <head>
    <title>用户界面</title>
  </head>
  <body>
  <h1>这是一个用户界面</h1>
  <style type="text/css">
    table{
      border: solid 1px #000;
      border-collapse: collapse;
    }
    td,th{
      border:1px solid #000000;
      padding: 10px;
    }
  </style>

  <table>
    <thead>

    <tr>
      <th>编号</th>
      <th>用户名</th>
      <th>密码</th>
      <th>插入</th>
      <th>修改</th>
      <th>删除</th>
    </tr>

    </thead>

    <%
      class User{
          int id;
          String username;
          String password;

        public User(int id, String username, String password) {
          this.id = id;
          this.username = username;
          this.password = password;
        }
      }

      List<User> userList = new ArrayList<>();

      //3+1
      Connection connection = null;
      Statement statement = null;
      ResultSet resultSet = null;

      String sql = "select * from t_users";

      Class.forName("com.mysql.jdbc.Driver");

      connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/sctu_javaweb_2018?serverTimezone=UTC",
              "root",
              "123456"
      );
      statement = connection.createStatement();
      resultSet = statement.executeQuery(sql);

      while (resultSet.next()){

          int id = resultSet.getInt(1);
          String username = resultSet.getString(2);
          String password= resultSet.getString(3);

          User user = new User(id,username,password);
          userList.add(user);
      }
      resultSet.close();
      statement.close();
      connection.close();

      for (User user : userList){
          out.write("<tr>" +
                  "<td>"+user.id+"</td>" +
                  "<td>"+user.username+"</td>" +
                  "<td>"+user.password+"</td>" +
                  "<td><a href=addUser.jsp>插入</a></td>" +
                  "<td><a href=updateUser.jsp?id="+user.id+"&username="+user.username+"&password="+user.password+">修改</a></td>" +
                  "<td><a href=deleteUser.jsp?id="+user.id+"&username="+user.username+"&password="+user.password+">删除</a></td>" +
                  "</tr>");
      }
    %>
  </table>
  </body>
</html>
